SHOW FULL COLUMNS FROM `tool_category` [ RunTime:0.001352s ]
SELECT `id`,`name`,`nickname`,`pid` FROM `tool_category` WHERE `type` = 'tool' AND `status` = 'normal' AND `pid` <> 0 ORDER BY `views` DESC LIMIT 24 [ RunTime:0.007542s ]
SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980988 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980988 [ RunTime:0.004255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339826,976469,535562,43161,293444,718454,700549,345784,49275,116342,388580,852691,666653,537078,164320,813845,754291,93236,30864,372198,62849,723438,778889,5180,535693,619129,800639,489256,851389,716969,908340,806338,870985,555910,26265,637939,334182,679385,87538,144132,878358,886364,892769,881247,940135,177203,304482,186296,443166,306976,670946,77954,670568,211580,208399,147132,839698,256809,206230,920774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000365s ]