SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040541 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040541 [ RunTime:0.005899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660919,221776,1021719,945601,1028265,882413,350571,60616,453286,871250,801813,851438,570826,130461,378746,830334,189394,235061,479158,238415,679894,1175,107019,822304,711249,590962,308433,627471,925119,437375,584855,902072,359326,836113,29028,634308,357455,1045693,290399,922465,764505,243296,399803,602100,560110,57078,560476,752979,44292,583944,175400,268397,402583,828914,541353,259712,2358,588735,107785,305075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]