SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405875 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405875 [ RunTime:0.002636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61663,377981,104419,3686,52038,543224,344512,52233,492321,259643,796735,815867,388288,76814,779238,197485,720866,409810,142788,288267,968573,870360,385287,768420,17017,885002,965457,379073,945567,828228,698267,985708,976535,100989,203406,251879,687170,453955,840312,450914,1023889,28997,534407,146650,31358,476560,458243,918210,714856,349467,987118,914093,462714,58330,843842,403153,47757,389708,542267,976567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]