SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339623 LIMIT 1 [ RunTime:0.000873s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339623 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735379,423726,137180,487467,854370,378726,1013726,805463,44763,690650,419695,85372,197281,162313,806065,586695,281184,924520,191653,105305,411648,838703,206514,211883,314170,488063,51247,532365,974691,575815,252214,634970,262096,739702,434916,390148,124789,354912,979277,504345,451686,525106,271114,527453,450786,609948,363925,40153,768152,759980,54518,955509,1001072,936282,378376,228463,231435,107722,907889,938657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]