SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102563 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102563 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11268,128810,692340,901859,97193,139568,157536,209872,683180,41560,626986,885684,616033,279916,177532,22629,462082,1011811,1046311,50775,665504,267883,419277,851588,902317,290852,928146,628285,357379,509482,671567,822225,961739,724277,416207,362112,686097,472915,910043,966771,805889,371492,730755,756368,242842,576185,602113,135309,608480,289779,528351,1013124,450719,479946,263934,225600,399450,1044033,588225,921057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]