SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801423 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801423 [ RunTime:0.004024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223961,921854,710476,183347,388016,47801,1002072,271524,657387,756877,376894,165213,191648,199741,779790,480344,277291,378688,967704,709825,675800,1033781,248439,239774,653227,34948,39258,912300,59373,295068,285560,11051,613765,52861,419520,669239,1023888,12429,905367,579445,719056,643023,453510,154450,705413,740761,773419,571615,188702,500087,867515,612131,229122,213103,177654,1027855,689798,189118,471467,866341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]