SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013389 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013389 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613284,945620,976374,31842,306324,274197,453739,463881,172906,397487,1023370,445914,861648,363597,340583,859777,669278,866399,311974,414782,218412,175684,935052,331804,877473,1034562,389550,932662,352115,737199,465641,508062,469201,361451,475262,1018112,946280,517098,608060,412509,343925,471124,654011,625429,553508,16994,45196,591135,41073,40380,36394,95401,776197,882525,1016146,126879,954118,384063,372945,196832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]