SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411190 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411190 [ RunTime:0.003755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259599,420559,5677,559683,288071,1017803,383098,962237,681477,469207,876565,369234,68105,832358,324809,55184,671933,995658,812151,792013,851866,525504,110308,112159,763348,573682,508466,552192,975934,420624,570379,75414,1038431,791573,490605,125693,932061,244141,188429,326582,565233,951322,460466,953856,14693,976841,787266,870109,79406,128799,728804,434747,123180,28765,732879,13183,739711,87842,854348,184345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]