SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002713s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482168 LIMIT 1 [ RunTime:0.001784s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482168 [ RunTime:0.007174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367653,487870,424811,488540,278285,974469,281780,135529,913177,228274,898533,640260,267997,90053,433972,969832,1032004,272507,680520,748625,478490,206549,296433,95057,465443,772442,29601,1011437,519226,711155,773882,470128,421400,658416,611844,325395,450754,489116,339659,196304,984368,203046,772194,637708,343088,383626,24628,956096,707194,723673,274659,405075,232443,890554,928100,826119,496549,978129,707058,387376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]