SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245610 LIMIT 1 [ RunTime:0.000605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245610 [ RunTime:0.002508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670696,58950,420334,384019,1045982,330735,737769,812887,860388,112373,998056,590544,807165,467373,1022275,939983,387214,394272,535945,862595,1013343,238217,770009,397410,311321,380451,328268,12296,577443,581524,392279,410110,162910,19680,108386,780978,56205,530197,738277,811100,997008,393487,131552,431464,764360,25903,158932,700652,904642,498629,163567,13190,136474,724189,467995,283457,834804,929284,624338,729754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000891s ]