SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 694523 LIMIT 1 [ RunTime:0.000703s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 694523 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763428,800360,1041203,139200,456189,182557,901159,640491,540300,186579,122827,1002791,27311,934385,161593,42229,919035,8554,114078,933221,355120,526418,771943,254928,880771,72794,668297,129810,538927,439405,715641,731237,396101,479325,107569,631333,241489,526847,218949,121171,177164,519462,196890,22558,559867,392694,712237,1024963,539600,859426,120069,60592,733911,929365,104184,706261,993464,620812,813647,819341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 694523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 694523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]