SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457059 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457059 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151257,981684,164809,274206,313873,640492,947351,286022,1012078,491620,785755,322373,432532,984782,469618,109835,114517,427000,113645,1021718,588385,612351,446350,249638,192769,419683,163902,793398,190416,71045,578560,1015648,471805,310913,969244,80745,229956,179899,780730,280011,771305,158604,960311,786145,1021745,286469,45526,882726,142430,403232,955503,1048677,933291,555423,503258,127687,781592,497929,604252,135720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]