SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530506 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530506 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993821,566734,78613,56877,941352,813178,276724,213371,389990,279798,430666,295901,675350,858066,225669,589623,465231,181059,320349,305769,778481,856708,606874,665165,929591,199155,454025,178281,841817,618589,216045,837161,822763,980683,280140,1036651,153524,403945,512343,308570,867946,124252,957362,995084,14806,881410,295802,341663,884286,522404,839887,257942,120158,948028,8761,809784,41073,792309,133862,99821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]