SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437041 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437041 [ RunTime:0.001363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607594,504570,1026853,24611,710575,126611,365585,465770,493363,677691,748560,155362,1048061,909411,492832,81530,123486,746304,789452,590116,100832,224966,754864,544919,124591,294782,572691,681221,311412,450924,1032266,1048290,918923,874398,1035131,562859,642105,334604,831863,679354,592227,509085,402247,886705,877431,551674,1044470,1040899,876322,488420,874005,975963,348686,700163,779007,535259,818549,578463,274379,98916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]