SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503060 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503060 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710657,933626,747311,1044668,946903,46154,37372,434310,869765,36871,724890,799988,460730,1048868,918140,763264,804703,182945,371321,309116,279958,949175,690678,770761,304826,715854,249398,5679,516232,903259,12723,425204,732108,135859,220153,267533,128835,701659,670500,78982,1009382,854243,961678,413477,149771,145122,895231,467040,562439,13097,119913,231881,767915,507820,699969,763454,180606,434408,919336,267752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]