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` = 50702 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50702 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583694,182858,74924,800420,976982,840776,166233,262722,77156,882644,788307,801455,840294,975594,223787,767596,892020,824399,395609,789948,246825,644117,1018934,62902,633199,572468,433351,412014,344074,1024979,380072,237188,433471,941813,1034401,190869,153832,410037,592665,158732,310079,630262,447206,353217,972183,536441,330867,872238,458338,434315,960030,662928,515342,429632,694737,357735,901556,775879,200626,462936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]