SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39158 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39158 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250566,645457,967275,413731,984524,600079,825659,222810,147951,315819,979571,43046,247010,736383,288477,230117,1027277,503877,4784,639140,934698,383343,347023,643086,618714,503156,447999,231151,472470,987686,662690,68092,180669,379787,667894,856938,317868,830608,443132,665394,144856,638564,515380,424092,855505,747543,389946,605777,800991,337975,129353,62142,268421,655862,546054,226657,623412,439818,389553,999733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002545s ]