SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494830 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494830 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456084,453390,163677,709384,7944,1042225,539012,933121,380328,470554,180319,240236,655231,360370,116409,835017,829838,168312,662599,299940,706475,392964,98903,924478,501712,778927,210743,1028064,942637,377884,743125,827221,347359,138455,625492,759904,24190,625004,888516,345222,677153,95551,302645,236448,466642,853727,999571,853136,693981,656823,394472,146930,316126,1004281,197175,759982,10634,506956,376253,472833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]