SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000176 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000176 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1181,183996,317219,434157,817013,788961,299864,582257,340652,666598,684610,45093,336146,546080,86016,681948,150834,317852,22897,647449,518233,312448,490595,526758,975704,376659,715979,644312,258868,471800,959735,597062,327235,1009129,982226,829739,355001,670697,380954,739309,315349,826026,28407,499570,793515,424738,904194,88602,673359,391756,216720,482657,70014,341009,984425,437747,334284,948101,492336,817903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]