SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34484 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34484 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030413,327676,209561,821196,300145,526686,230092,533481,437194,858070,950290,712150,117289,153389,298594,302782,1016901,664596,1037056,773778,118480,254807,513712,511557,1046271,632373,568813,286042,48099,616750,523451,670388,852981,1033672,788023,615655,752644,306785,341064,644728,891690,610379,954689,122751,841819,985351,396732,342885,333601,883271,501108,948360,1012668,22500,438690,929302,119968,627797,225195,305453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]