SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013964 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013964 [ RunTime:0.002650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102831,262640,889199,603015,960825,763308,174008,897773,243088,1048437,703301,915941,999201,268072,677694,949288,835106,84873,858671,601706,453795,58850,513361,871479,57386,760619,673975,907848,343393,843805,860792,104931,75036,301219,126933,1004401,620451,859464,114742,519783,189153,390935,9314,620220,1008227,693090,881822,358430,156253,480723,19382,182920,47926,1034604,342129,808313,548480,202513,219217,881582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]