SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805615 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805615 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191990,321058,530512,1010319,673203,633215,7281,783613,188497,667734,934189,245635,947213,476866,34723,884319,140092,287990,241548,103260,332928,653503,293189,572595,736508,162063,225604,806706,657482,167960,143722,850238,397337,115684,441197,319484,529423,606209,799861,713715,623872,115394,745898,268097,126321,831560,975010,292320,234366,24399,803245,926212,485488,572778,405829,427539,853838,81588,275906,918849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]