SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021035 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021035 [ RunTime:0.004426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536139,275034,326431,706275,316424,931307,841205,395653,80554,860154,254842,159149,752016,206655,28166,654823,176181,883329,121463,551400,665719,777062,380130,360052,687385,820954,517296,454419,917483,104735,693089,488991,893301,910336,956229,174617,949174,838776,941130,410629,570489,498879,10151,999222,767596,791107,117848,369925,252455,257412,802577,250150,82629,447734,455800,880275,455229,301781,922190,926148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]