SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 749891 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 749891 [ RunTime:0.005575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488801,362961,294354,482091,3844,424880,220569,796857,679616,267738,890219,535672,269954,711591,120406,47982,615090,599207,154946,123856,870345,833926,440789,125609,342570,555461,61274,324618,394114,418525,445857,324025,714515,932675,151505,359149,962740,304223,472838,238136,651707,915102,537756,920107,360632,932553,242942,550552,806475,682009,205227,1011217,104025,452444,192103,972034,595068,101318,833633,674359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 749891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 749891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]