SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427653 LIMIT 1 [ RunTime:0.000626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427653 [ RunTime:0.003372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013590,990508,844731,448143,45660,261111,894813,486129,989256,701543,876291,673607,463150,517261,829441,11945,871168,152247,207924,703580,103809,610504,120370,707014,875287,517544,103921,579356,645505,770902,437833,527902,352348,727530,99977,264781,193385,16940,830365,104570,212296,858989,752205,282159,78982,170854,454957,533858,47882,457590,801905,437764,224030,527725,473143,1011651,106887,303143,875381,469304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001283s ]