SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411668 LIMIT 1 [ RunTime:0.000731s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411668 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308248,488,1041037,769644,293560,1040272,505026,885289,955326,575789,33073,295307,521733,400562,547932,333354,418819,341523,942635,383419,77528,225928,160804,720842,502366,138358,592730,39183,1046015,489366,708738,231280,189134,533095,590054,325646,79431,909596,535362,1009698,42945,819137,611514,152194,643506,11553,960814,93693,641065,5642,856380,12611,700258,150813,226367,632560,395997,476946,932431,62218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]