SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972010 LIMIT 1 [ RunTime:0.009385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972010 [ RunTime:0.002938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504609,361140,54560,352405,40031,145769,421124,274938,137182,568446,59566,869610,315571,806464,275020,75287,6283,127433,259660,878844,476800,923293,828484,779620,782084,353520,42394,19779,11786,121335,840347,719561,958265,840265,472360,320329,819021,111258,174680,763225,1000529,74438,407094,961152,194363,587351,1035825,85944,780968,1035756,426656,64046,446300,622950,37769,925695,208106,557665,1004147,599885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001320s ]