SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043470 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043470 [ RunTime:0.006008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535229,452050,417633,571399,708920,935630,309607,175761,448491,544380,988228,971334,921319,718588,443093,356354,349209,364941,739735,219805,415764,116930,23032,802196,352901,34689,525938,875492,831247,544956,596916,672990,1045973,91894,300225,367793,459556,220132,13122,993763,60735,1037675,396627,759639,7666,761008,382928,812537,364836,133859,277436,381784,57867,669967,790885,626104,849849,245902,436797,290447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]