SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004648s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488712 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488712 [ RunTime:0.008588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603841,173034,241170,754179,564173,426921,618717,674869,77376,312329,1025075,234345,835029,301127,712774,847086,957293,453436,538375,992499,943883,850617,5649,90890,855603,866293,553180,823374,803139,371777,1007345,473128,411558,429350,631292,891584,501925,167106,487461,177511,227490,667126,260049,722919,678909,83695,998900,596940,451100,955020,660820,855850,741807,529035,140729,853272,444838,434625,227856,500477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]