SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516984 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516984 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147583,275632,594737,99428,197628,57887,345023,111499,358431,418546,669592,876008,508525,610726,221324,607239,597925,470763,1041586,817016,368935,457174,5124,383442,331777,1003375,993516,62618,744857,74357,284611,136458,480624,274940,995081,15195,568499,1034757,208114,86344,521967,546642,985360,211960,370343,17785,546957,216607,245636,462750,1038614,1044693,728161,962257,893779,756103,374459,868709,404683,391240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]