SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410458 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410458 [ RunTime:0.004423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239165,21095,154841,871238,834959,613443,337254,374759,248326,72957,51498,589906,893984,964667,598246,572040,364432,343221,555289,365245,908792,760986,503774,875329,765466,233846,497866,247890,548767,507479,594648,242324,816721,630339,683957,19000,19980,795448,587248,77697,835090,350855,611847,155467,458482,324879,906955,919518,791365,338688,789144,378357,782544,482615,906379,456960,597688,650528,430766,54057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]