SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2943 LIMIT 1 [ RunTime:0.001344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2943 [ RunTime:0.003721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033561,158568,216442,871077,1046448,1006127,12549,85762,52832,544920,1044158,441587,398854,455719,202454,742545,971584,506961,760284,65291,699340,210593,801089,890386,781965,899336,648563,694954,371861,902488,159113,488351,471690,350373,44110,1028452,889228,844890,58558,232874,477129,211832,916114,961758,732143,892592,706155,645946,1014048,1010995,691935,191946,325603,86275,684651,854026,44622,597673,1040309,230292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001268s ]