SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002518 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002518 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010095,551971,720736,353601,794918,778861,957879,858665,957349,1027380,307410,838950,189400,708877,705129,945143,506956,1027672,51462,825157,746719,748799,683322,337449,291312,501859,560440,647843,1036698,274074,574220,929097,556662,59470,831825,340700,17551,488806,980350,83517,495822,851765,397607,970467,903599,941821,239277,653285,990950,629198,322617,318842,498453,646639,254559,143378,234136,897598,243772,862744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000793s ]