SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000103 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000103 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574948,299011,234660,762846,25484,555239,1027632,28017,538012,841059,353829,216465,253476,103616,676886,49043,640360,298054,211070,991397,265199,362544,848236,667391,985216,682649,353000,882908,603605,923039,315943,995757,986518,616932,539452,325757,962498,121626,724339,568090,831073,82365,403688,564831,713148,374366,300289,570051,514819,213886,934690,203828,593325,97884,934438,149264,23608,456066,54602,801844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]