SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986987 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986987 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357313,441888,201531,1001133,85381,754675,998288,18266,342197,334501,419456,940778,712014,257247,70025,778329,992108,903188,789615,1013319,377238,874818,656474,180562,817791,438169,341634,371424,254461,196763,1045847,310483,163913,1031630,993378,34311,365218,505495,366057,845795,41153,562485,313127,716766,445356,343403,877052,157770,394044,416246,105991,985361,242364,9165,465262,258788,809851,817326,316617,340612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]