SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410110 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410110 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426175,713236,666890,163511,1045181,843546,920880,669891,184302,295186,20039,624626,980058,714968,529165,509240,370352,713694,547754,44777,143061,815600,585312,333055,525727,319498,235727,692243,785725,25837,690259,670828,205645,346850,860969,641760,558010,903615,151623,320864,567021,296503,634729,318174,74848,1047217,608355,191780,604452,254608,966768,70182,122932,10781,180873,821064,454898,764435,266762,1010513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]