SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53742 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53742 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122280,543659,183026,1018022,869112,717793,853820,882361,612145,425005,349821,236341,697002,10368,988560,587308,352655,404425,262185,384194,1020032,100566,139221,201507,644292,84110,408972,641778,988889,208369,476512,954544,419740,860695,443455,741920,655414,809913,502350,974401,877211,14683,1010315,373126,973329,537594,909848,982430,767489,809057,674994,48906,597447,95392,297286,142769,957278,654522,696123,657477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53742 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53742 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]