SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017491 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017491 [ RunTime:0.002292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326236,935791,816821,423314,308841,185165,584603,85968,394773,165257,679497,661718,884941,531234,91061,117456,23543,317733,1041837,575294,515073,467097,209560,922515,197282,893188,540903,322679,809375,148591,1031681,544618,823873,82591,457311,815296,300153,219634,5934,591166,621908,658193,1025723,1043659,696898,443399,626676,496706,479657,94581,420365,598675,367315,461421,384742,286089,492332,159623,395223,781676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]