SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310683 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310683 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422845,599419,147417,600562,454962,895459,472790,704275,867978,449694,113829,951715,508708,899650,114324,732413,543402,987912,880750,984857,461991,555259,644119,392507,949041,594754,397577,16502,242875,42556,498139,969791,73412,493401,64056,1032098,219565,702632,834322,799697,555587,992333,265318,565024,527260,775459,332153,1048753,593470,143841,292039,154994,368409,631359,919474,478571,499561,502443,972288,934728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]