SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110718 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110718 [ RunTime:0.002990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007128,437451,193176,727745,179803,1014257,423714,981031,166780,109364,979170,569190,293521,705110,914333,537559,256726,741864,953205,184721,787907,613509,212272,352262,145518,807667,151034,212438,342428,822969,519529,265456,1022657,131212,535221,927391,675455,118707,934982,13919,171572,43589,667007,122280,453338,597865,360425,15924,412800,94728,423746,25519,340861,749322,796537,817986,864164,295723,731785,157969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]