SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4702 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4702 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58470,587941,715721,645110,184556,308219,675757,196713,407170,196933,47332,446315,147220,806416,542442,411341,718599,840984,654869,795030,604066,547647,381562,676513,138542,596031,206532,240690,579129,155813,39439,152320,181121,841052,538332,737736,593930,993136,803811,1044355,75947,490018,665009,353652,814658,1020001,891801,96894,46211,365860,600757,1018194,1047392,531877,793350,949946,682016,697592,285653,913307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]