SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001984s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409529 LIMIT 1 [ RunTime:0.000848s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409529 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661151,708886,874065,401115,373824,243131,302567,169635,437973,418641,592452,159690,17813,1008152,290633,727817,235603,119021,615719,666413,315052,143399,470578,889438,391480,178855,766649,497745,94519,5162,340447,394734,110404,470217,549416,1013502,579425,828344,754088,363925,549261,573110,991670,227671,595354,39681,515321,695617,451878,328299,367810,558569,838891,599616,226279,508034,902720,225773,735192,167866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]