SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048121 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048121 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148410,144220,490906,872077,71919,149151,719202,1005188,57227,654823,819541,608385,593682,418064,806030,161943,407572,640348,932710,440045,30267,229144,104849,869247,676147,131725,624009,779435,892328,233954,915611,512317,43041,629046,711031,27458,140963,787021,114818,74054,427297,431871,612872,996721,811432,54450,605965,424991,429463,527677,6791,658061,442104,924777,361702,100483,452974,494156,611814,545703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]