SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411368 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411368 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263180,955938,708519,378911,539240,677295,314592,189128,765654,884579,516945,107050,929578,308281,78823,1009527,487825,448311,239972,813102,967635,413384,597345,465647,294165,748620,846364,258536,873471,557077,789981,214803,174722,991860,1033206,142768,842084,672350,534943,684182,799833,921794,866469,313181,323170,280441,953122,789452,405408,962088,954930,752245,55954,185315,154690,578286,589154,627157,789855,304603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]