SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048917 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048917 [ RunTime:0.002283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604257,667246,385084,587740,1006609,637819,433843,847815,11018,367046,120265,1007686,559542,551650,463274,192085,620060,457053,722386,239849,166370,186594,296821,479740,513509,745637,559569,524227,253069,402350,214457,786914,194752,728059,704097,828904,734166,13710,809220,119342,425349,878273,507211,626227,159163,142502,439281,705787,408045,434849,412986,89204,913902,152270,266327,453118,426165,238921,562514,307305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]