SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175543 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175543 [ RunTime:0.003654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763413,941765,394422,248795,123450,410540,496407,594353,200559,479670,415807,352490,675045,354658,843372,502614,481718,809460,317045,837629,200621,772977,55993,953861,1551,583599,985886,693025,180239,651155,464630,591608,73965,175764,1037263,713058,210504,209804,464326,186927,530770,299719,932495,397971,855094,279880,338969,288374,693929,275513,323038,989607,615811,161041,734019,481776,356604,926790,743868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]