SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004121 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004121 [ RunTime:0.001423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142151,858993,69019,1020245,617075,700716,967510,389672,811821,939415,805190,809047,5674,824763,683194,748775,121493,879953,949480,1020643,397352,51577,523253,1005015,499057,739706,751141,307145,653423,967391,405054,32908,239466,923592,538735,903457,819994,689666,394826,744452,1001222,1026094,293991,555393,700130,971553,301188,825549,668155,541635,955890,161317,437242,99411,508043,311256,81310,109211,957818,466832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]