SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020680 LIMIT 1 [ RunTime:0.001726s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020680 [ RunTime:0.002131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828848,896469,209662,187214,953360,133580,37745,334601,832618,773416,860061,106423,423652,662414,489743,645043,283128,883288,996863,103042,792056,709343,28210,110061,1019775,1011630,865949,946280,239571,915399,692561,850538,196897,59634,402212,312135,299650,838024,901632,14362,709552,39447,187500,866189,806882,127096,14759,18367,485332,11239,587654,875154,317458,312345,437996,889628,514826,552714,891672,564125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]