SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201740 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201740 [ RunTime:0.003765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456957,928486,404467,414548,685373,27632,867793,390744,750328,906236,984620,341490,706293,521937,635016,597282,646436,1005332,787048,417917,3262,295943,259416,475805,266955,964483,820430,719290,767330,875833,17118,306057,754199,90364,736895,948857,709496,359996,924268,727867,162975,322432,317277,617536,508190,720735,186904,58844,138122,941140,850984,338014,151780,572444,975269,773824,825271,827207,382590,195691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]