SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984901 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984901 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210340,600646,1017903,753517,834664,1010888,778716,365016,616130,398676,438022,921664,493101,457462,527085,380023,874860,505725,356492,699342,634179,666405,955648,459499,366790,390064,540803,924543,855662,711237,278317,45214,968544,73741,192031,494661,174678,968477,390574,206289,259515,337434,639393,525532,885568,54786,446552,761844,345859,446454,188968,836986,373898,833881,248797,737410,36322,196696,423949,879213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002874s ]