SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48300 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48300 [ RunTime:0.002635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725401,742048,207506,439283,170629,804560,812333,68882,786595,25322,740563,593386,319107,65882,166048,1017002,717345,787410,240520,419752,503000,708648,653087,997037,627483,276329,322417,977556,737396,91538,987541,125675,697715,155901,971923,503821,623878,15368,111880,191548,72442,701019,327841,299377,707942,708156,358975,389362,189513,95148,562252,346584,709309,667159,764739,13052,766794,726,446833,790376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]