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` = 265284 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265284 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539041,1004857,254838,577691,581626,173225,961508,488988,889027,878895,307291,971501,531866,936892,341147,256754,642675,541714,395920,864449,451023,442042,529953,2182,1044812,116344,615417,69855,638385,866692,281034,205454,300402,871333,1032862,195903,577860,628512,801344,657362,345689,191138,248056,193378,9902,239290,612743,106602,704287,100935,900284,462997,399210,46845,699905,322082,184507,177006,585431,12667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]