SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40030 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40030 [ RunTime:0.007431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477974,424185,435294,853879,585752,749936,525411,157762,864771,182039,629740,191821,194260,822164,899021,267445,1012004,162967,260183,938257,944318,979368,335980,405792,534649,357072,421071,123115,831857,140289,37448,344905,555975,595305,655761,100001,333391,344196,377242,504375,385083,117408,634992,459702,47511,104771,712038,1042320,360959,486779,79512,738882,420286,326906,468047,527030,775312,311649,60100,112728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]