SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437251 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437251 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502798,500971,14392,343887,604562,508168,153164,119062,859899,796475,539548,278687,759342,897361,317545,718758,1046371,613255,138173,631942,94197,680647,508537,1032315,73646,119274,29242,440506,1039026,28987,131903,973494,817339,640758,903422,975893,858136,242609,1044064,853380,987035,13906,237829,770141,993382,862971,122467,562675,1023157,582473,306965,338398,162564,469301,666053,567115,678762,217123,153856,310674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]