SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042797 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042797 [ RunTime:0.006892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254458,765048,673318,883965,324860,769427,148061,255665,578674,922549,677292,473221,770117,157705,229789,807190,499032,916517,350206,426275,554356,601475,160021,831787,23843,488599,125117,279693,908448,920909,979744,900960,750404,476623,73460,925309,962973,944673,122750,591799,704136,50110,984974,325445,20611,889227,916732,987234,750473,1006354,505149,955114,921069,77221,52150,995393,408649,435213,795801,928411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002108s ]