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` = 510326 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510326 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562045,676827,799189,965983,265514,1005940,279270,550929,141197,501714,144753,655401,13546,1011008,945534,955409,454083,369774,997888,423800,660734,518703,977330,402072,186024,795903,914405,897175,577818,555490,918588,107192,859760,1002374,303396,746943,456105,1008755,579550,845216,135045,740669,678097,978670,220929,36535,520116,209988,998743,1029188,771137,537510,458759,115362,306644,461152,187719,33433,956615,525022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]