SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315086 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315086 [ RunTime:0.010339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13237,681720,524608,316177,256117,323444,827844,630311,832036,838347,939519,529072,340853,99035,823015,677936,545018,139093,915108,981614,875651,627131,902829,655624,49579,992428,898291,828381,235173,1004334,643253,552791,824373,834598,202834,550339,463131,877431,470160,364268,74376,1019278,177565,803676,132228,98346,519178,707773,987948,752620,715327,474064,7635,809024,800215,489675,34936,605294,434954,539558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001329s ]