SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351209 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351209 [ RunTime:0.005439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372879,679821,202452,377514,317545,177375,225076,54402,395130,662945,190823,276508,941293,110409,874792,612175,1045399,391235,243918,486288,433161,16077,1040303,277104,712880,641596,687267,457835,649713,541708,490405,402675,595982,240172,1025026,633420,673235,91057,775018,639203,612738,915335,614060,890580,352685,971563,471506,237095,210125,1018390,914007,302300,14299,389955,731853,636272,747738,919823,791888,842441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]