SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518930 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518930 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101275,195977,329002,656928,540857,281441,185249,758197,639902,795901,486698,230807,615609,128439,592233,973039,1000878,335600,358220,320270,122293,227797,580965,524211,343839,774506,797318,120588,379548,45635,435707,954781,359376,197580,836333,729873,944884,93987,162751,519180,103165,268110,965720,317720,842719,650670,849118,727525,423183,137026,199080,493182,54707,603918,18483,536147,938964,627910,94626,818496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]