SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44950 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44950 [ RunTime:0.003020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565861,12391,902054,1021229,83119,30969,754035,22893,130021,597559,285685,733513,138723,592368,210201,487123,863131,154675,850907,811972,674001,797643,929475,1041484,848172,708477,314242,21745,855155,636705,45666,665309,780842,104532,481645,544703,55689,362524,842542,217031,931336,549984,697854,473416,544687,317371,429945,94102,380137,519649,197974,794480,974878,85214,178956,75489,842168,478170,101453,524128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]