SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521410 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521410 [ RunTime:0.002359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503292,390918,944250,667189,132459,421374,479037,243997,615089,730904,510794,606132,278266,681307,668578,667037,996928,338174,887761,473259,755842,392958,973908,366116,419491,432231,762038,604095,49639,964557,530394,136483,631058,121988,18514,947122,62129,873471,21113,386975,723064,971033,606081,193768,626011,226660,629609,656259,1044877,979485,441615,40930,521479,1006560,347019,665758,681357,802921,133944,631813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002201s ]