SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028696 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028696 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392409,715225,237947,754736,202650,990509,25511,504767,353681,544122,532666,193241,918192,548140,961451,899676,673669,704442,839896,544964,900047,678593,450451,150733,552014,122049,859524,603246,43543,127243,206515,198038,693515,652018,169395,933274,389559,952872,666947,1042875,927686,457953,363927,914003,745525,479423,12374,622102,479239,977461,679623,965365,864237,834934,404305,695268,92261,710974,158346,830433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]