SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 818009 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 818009 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100213,162850,117432,710529,20118,806767,279115,332016,97368,71503,681260,726746,672101,104568,649014,252485,194383,512180,414353,904821,70677,331109,365650,1036366,225516,896097,480529,861863,608681,256378,1040059,482820,545298,388566,684060,166340,536713,357578,511908,455046,195893,355833,770531,109619,923352,824481,638235,555226,349319,328940,817739,971983,390031,1043791,960113,546964,453010,687336,587224,901154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 818009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 818009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]