SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311104 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311104 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459685,256915,667627,382921,990697,1005682,654813,247635,871874,770899,863238,243602,478977,553464,294389,199554,604549,27910,304103,815368,859288,954354,747575,698144,593591,281883,624894,705525,626863,808669,845379,444334,195851,389970,199256,179204,717024,58928,803885,493612,563963,755359,332627,269086,142799,2336,561810,885547,161581,1015587,373401,982617,506903,712975,330002,914144,556952,132476,984714,402584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]