SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40188 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40188 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293368,973942,912616,954257,209066,540921,644146,607423,758783,624451,283578,1045141,130648,38116,543473,298301,1020724,760678,848474,233634,419417,661506,718742,618445,49613,444759,1018348,549946,198194,671991,9635,412897,48997,37626,954717,764998,367362,545102,192980,769752,759359,262671,937152,853153,776780,455184,400352,77148,998702,818770,691575,422554,102800,143013,175153,877379,703040,306119,788501,1002276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]