SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047740 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047740 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572099,110400,86898,170813,817776,127173,189044,849822,773056,468400,6745,1048153,89551,218731,159381,239904,672289,463613,543112,739405,1001369,430906,946545,367619,393286,969620,45577,180466,434576,736499,985706,313917,160956,94108,398322,44529,760275,387035,610185,1008101,367906,780365,297,248084,141798,858612,116881,894790,459420,977778,749753,348197,519459,326894,655784,217602,41221,896521,1030071,704037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001264s ]