SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568032 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568032 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811593,940834,1011867,590729,38572,116464,824555,544560,56810,182816,815369,116352,457438,429507,18667,1007981,773405,504186,828487,808902,961559,1031823,954975,338587,461136,79442,468549,223825,734985,118364,546442,893896,873565,386143,1014574,395996,690549,912149,1029288,565601,104691,613614,657305,885606,780943,571266,913900,762062,186591,462108,414103,481757,371725,1022517,549419,353281,77717,574993,804694,910624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000843s ]