SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518470 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518470 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944050,485008,445217,952423,540856,490142,445101,693395,345034,691370,88580,281275,866166,442797,1022306,893958,937419,495675,837754,344056,485901,580075,310614,828042,768155,603926,829920,530769,817240,29277,436060,133427,36951,720399,91038,138532,904655,341676,265685,727999,480271,66182,11249,537164,158137,316699,316779,694365,384783,198511,691563,1002036,743790,766146,124335,294757,968092,786628,54936,151793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]