SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378118 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378118 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512692,768371,672831,582125,749406,556994,224404,253180,10267,974218,846891,123842,377402,238719,407444,340549,185342,960826,334029,449430,599176,700723,794187,508702,70663,965561,744904,571948,723811,704308,702177,103060,732881,1005763,909709,266494,340669,723331,64643,316045,627450,615144,31193,1001573,919107,215767,237011,131876,368816,689634,602938,49207,832477,662287,757593,494136,487397,574267,215892,929385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]