SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102943 LIMIT 1 [ RunTime:0.013346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102943 [ RunTime:0.004804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136985,611405,551923,790848,633282,492929,86946,349695,209673,553552,509892,248132,623544,539806,848927,735089,409861,295897,389075,839616,929121,1044169,625287,608822,212541,53255,353044,709968,819072,508783,727844,540279,198314,60261,937370,713800,6599,1015602,570321,791117,681156,820988,915988,770298,969769,774690,408146,849677,404378,651942,784874,324433,708085,594675,938111,406633,519599,557638,706997,378457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]