SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472818 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472818 [ RunTime:0.004051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473632,180467,505770,549444,574089,531346,194811,695906,974451,731908,289712,623999,568568,371065,353822,466383,686758,755359,416483,851727,997556,484179,103970,286264,451065,10042,718443,834186,87632,38967,734816,654447,861830,791116,251949,12094,371107,994571,450341,818418,130265,812559,432297,746757,109406,607686,878662,453503,901460,523353,900219,855377,318459,331618,957451,312385,780282,622589,161006,933562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]