SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800140 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800140 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75704,675005,739889,163446,228873,513142,90028,162289,369709,950908,805533,686051,411096,360584,856745,497503,805030,463997,8182,891264,269733,479546,1015037,324890,371140,445490,491552,449179,1022720,923734,692088,182625,437836,4194,1015193,839186,812180,271918,55049,822792,809002,267492,757513,838860,899824,702736,302058,843218,335596,563146,34373,647520,346103,679089,709979,930304,109517,215555,532092,40239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]