SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549819 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549819 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949213,768969,793568,808143,234295,345832,988518,519897,675239,128067,746161,761927,619324,272814,506954,360353,424888,818377,338698,1009313,321920,523580,767543,962607,34801,1001815,331740,8488,195780,839520,969017,938809,373037,194161,84902,132677,310771,996416,422394,279958,268509,169167,939216,900544,659875,456201,489516,453136,765043,927608,359576,196051,14204,371499,702963,416554,957275,476014,548757,699481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001275s ]