SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554382 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554382 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392378,796128,591211,816861,836533,260414,102452,597711,937205,348641,395953,819704,316001,852109,863660,736951,67511,147688,739838,291025,872148,77278,860272,479293,398538,671449,986213,462847,833405,53640,818412,303648,333566,1045200,759663,807622,545340,288371,522871,1029529,988099,713063,812005,595014,1005909,443083,662886,55809,340876,379586,844990,141311,340942,271510,965287,313408,296403,485205,520458,372830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000929s ]