SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456680 LIMIT 1 [ RunTime:0.001383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456680 [ RunTime:0.005703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629927,224992,323630,187174,431379,589786,556374,192210,419100,222206,884643,793883,680900,281048,424189,987504,645117,1007993,106550,267674,296994,394176,458012,796601,625056,878686,904617,480764,175059,650421,309706,478988,1014637,333113,652568,846990,1020971,966718,797297,321927,471958,249467,549968,619022,576538,1012353,383762,396098,336593,447743,927683,604792,268195,665826,576797,82593,860114,256151,81541,272216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]