SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498982 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498982 [ RunTime:0.002380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000678,642827,13878,951987,49844,488817,20131,266838,337960,390332,447823,892360,332537,1005299,771889,923816,444492,340923,996236,551938,151305,730769,198740,603251,83090,720210,622987,463466,291335,782636,867690,334578,323165,881757,636732,26931,180118,637735,882382,703402,138313,820668,300358,519602,603223,788357,172723,613089,852374,818564,395714,475149,241295,953653,787123,993709,270241,317054,517292,241345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]