SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002979s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402621 LIMIT 1 [ RunTime:0.000874s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402621 [ RunTime:0.002827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840673,364221,720770,955862,445647,16641,979531,39062,758418,412230,107884,756891,175839,377361,13000,702842,554761,66439,80522,973704,118900,10065,952019,145803,454354,509757,834529,370795,1022102,245493,245490,859973,875341,1958,276220,1032387,990156,184153,740497,63843,292998,971356,110894,441635,397118,903784,176834,312691,780431,362228,502575,1045093,425691,1028701,195837,556864,769909,581691,143463,131480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003080s ]