SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581310 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581310 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567132,898005,708915,124633,807283,899689,922729,626608,1045151,401106,367819,258844,309969,242400,961405,878688,125464,869135,974607,165525,222315,737695,982654,106350,303609,562963,333408,485062,981704,180966,993124,224425,533629,912169,1025008,141355,561315,546095,998173,275956,299543,271962,670989,106341,56768,355375,815667,983129,142264,846212,854409,674531,372644,396515,397942,985441,75556,611545,579307,902817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]