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` = 404106 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404106 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876167,564115,144647,806594,167368,895388,215281,345094,995765,68617,764279,98458,741800,1017800,975785,119255,883749,860884,127943,838053,145127,549283,316566,694861,705636,524599,761053,319962,898471,818665,758990,938239,832834,811211,399011,550684,338488,791907,716016,134056,142149,1923,167038,792322,527294,875417,994807,470917,924612,459591,392775,981392,1011476,982575,194812,695550,677677,578062,946954,728592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]