SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41773 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41773 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50171,807002,144140,113340,362509,239583,1016831,143494,54653,16686,393111,200621,600318,75154,912718,371517,302827,423701,558343,680459,649208,777419,489991,70041,731194,459989,113300,434240,571789,270994,973166,313936,222849,59120,796064,223103,1043911,854198,1000734,666153,700484,555736,630540,141066,714614,872322,538538,519143,345564,993452,224973,869612,457193,405382,1035938,579879,768367,669583,336245,749397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41773 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41773 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]