SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340912 LIMIT 1 [ RunTime:0.002167s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340912 [ RunTime:0.005710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866794,101383,137693,758171,1034373,138462,412344,247350,435327,116827,365749,781350,641389,956517,484317,588752,193093,996844,739485,651051,259155,787993,390638,68337,244563,760574,914197,306472,885855,623972,662216,422693,345506,219725,228809,394420,184117,648091,268144,958913,547022,694256,622991,207185,365839,60482,563476,998799,786952,664783,895429,759535,153933,355698,280723,171108,611266,979212,754137,604407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]