SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386906 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386906 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40334,399633,442135,2531,3373,267208,623152,416808,695285,1000593,413997,442214,685856,317350,92586,621908,527506,469991,397311,658593,52365,439260,884606,400663,117057,457867,418694,463768,254591,882726,33221,723014,239460,589275,777496,342867,986288,874512,821513,630300,710591,771224,777943,704962,74447,768657,909146,908894,722264,174249,539691,401034,144378,552563,25684,338555,759681,174372,179682,339357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]