SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338818 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338818 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81739,247383,708658,989678,814946,668015,903676,907099,601495,288672,710418,494464,198140,761989,999848,4020,637492,457331,936329,718897,873803,302221,306915,559622,715568,712317,621875,306844,824397,513095,906450,93831,194640,568160,214449,731175,947617,655346,808566,192737,637680,642405,842201,517611,626305,411035,194453,522673,796089,628856,359438,309474,709281,902124,683988,411853,846643,113792,359034,865150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]